create or replace view v_singlewell as
select a.dataid,
       a.WELLCODE,
       a.WELLCATALOGID,
       a.INSERTTIME,
       a.MODIFYTIME,
       a.createuserid,
       a.STATUSID,
       a.DATAFILENAME,
       a.WORKMODE,
       a.A4,
       a.A3,
       a.A0,
       a.BEGINDATE,
       a.FINISHDATE,
       a.WELLTYPE,
       a.BEGINWORKDATE,
       a.FINISHWORKDATE,
       a.WELLDEPTH,
       a.ARCHIVECODE,
       a.QUANZONGCODE,
       a.DOCID,
       a.wellcode||'^'||a.datafilename||'^'||a.workmode||'^'||a.welltype||'^'||a.archivecode||'^'||a.quanzongcode search_val
from singlewell a
where a.statusid = 3;